@  0.000FF 0 0 /customers.dbfprimarykeyFFF00T 0F/employees.dbfprimarykey _RCN0OP83order details.dbfprimarykey1 ,orders.dbfprimarykeyF 0 0 0 05payment methods.dbfprimarykey 1.payments.dbfprimarykey .products.dbfprimarykey 000F 0 0F6shipping methods.dbfprimarykeyOW1&-#total_unitsMB(8,2),&-#total_sales MY.9&-#Orders.salestaxrateMB(8,2) 5&-#Orders.freightcharge MY1&-#Orders.orderdate MD 2&-#Orders.employeeid MI.0$(,PQR / %d '+Ordersa*SELECT DISTINCT Orders.EmployeeID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate, Sum(Quantity*UnitPrice*(1-Discount)*100/100) AS Total_Sales, Sum(a.Quantity) AS Total_Units FROM Orders LEFT JOIN [Order Details] a ON Orders.OrderID = a.OrderID GROUP BY Orders.EmployeeID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate) ?1&-#total_unitsMB(8,2),&-#total_sales MY?9&-#Orders.salestaxrateMB(8,2)??????5&-#Orders.freightcharge MY1&-#Orders.orderdate MD2&-#Orders.customerid MI?.0$(,PQR / %d '+Ordersa*SELECT DISTINCT Orders.CustomerID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate, Sum(Quantity*UnitPrice*(1-Discount)*100/100) AS Total_Sales, Sum(a.Quantity) AS Total_Units FROM Orders LEFT JOIN [Order Details] a ON Orders.OrderID = a.OrderID GROUP BY Orders.CustomerID, Orders.OrderDate, Orders.FreightCharge, Orders.SalesTaxRate) ?/&-#total_payments MYN*&-#linetotal MYAGEL2&-#salestaxrateMB(8,2).&-#freightcharge MYL0&-#companyname MC(50))&-#shipdate MTLf.0$(,PQR / %d '*SELECT DISTINCT Orders.ShipDate, Customers.CompanyName, Orders.FreightCharge, Orders.SalesTaxRate, Sum(Quantity*UnitPrice*(1-Discount)*100/100) AS LineTotal, a.Total_Payments FROM (Customers INNER JOIN (Orders LEFT JOIN [Sum Of Payments] a ON Orders.OrderID = a.OrderID) ON Customers.CustomerID = Orders.CustomerID) LEFT JOIN [Order Details] b ON Orders.OrderID = b.OrderID GROUP BY Orders.ShipDate, Customers.CompanyName, Orders.FreightCharge, Orders.SalesTaxRate, a.Total_Payments) RETCHL/&-#total_payments MY1&-#Payments.orderid MI .0$(,PQR / %d '+Payments*SELECT DISTINCT Payments.OrderID, Sum(Payments.PaymentAmount) AS [Total_Payments] FROM Payments GROUP BY Payments.OrderID) 8Customer IDFROM [Shipping Methods])8Company Name0$(,P8Contact First Name8Contact Last Name8Billing Address 8City8State/Province8Postal Code8Country8Contact Title8Phone Number8Fax Number: paymeth"payment methods"primarykey8Employee ID8First Name0$(,P8Last Name 8Title8Extension8Work Phone8SetupID8Sales Tax Rate  0(,P8Company Name%d '8Address0$(,P 8City/ %d '+Payments8State/Province8Postal Code0$(,P8Country %d '+Payments8Phone Numberents.OrderID, Sum(Payments.PaymentAm8Fax NumberFROM Payments GROUP BY Payments.OrderI8Default Payment Terms##8Default Invoice Descriptionerid MI<"my company information.dbfprimarykey8Order Detail ID%d '*SELECT D8Order ID8Product ID8Quantity8Unit Price8Discount  0Orders.CustomerID) LEFT JOIN [O< shipmeth"shipping methods"primarykey8Order ID8Customer ID8Employee ID8Order Date8PO Number8Ship Name8Ship Address8Ship City8Ship State/Province8Ship Postal Code8Ship Country8Phone Number8Ship Date8Shipping Method ID8Freight Charge8Sales Tax Rate  05 employeeidemployeesprimarykey (415) 555-5938 (415) 555-5939 8Payment Method ID8Payment Method8Credit Card?8Payment ID8Order ID8Payment Amount8Payment Date8Credit Card #8Cardholder Name8Card Exp. Date8Payment Method ID/ orderidordersprimarykey3 productidproductsprimarykey8Product ID8Product Name8Unit Price8Shipping Method ID8Shipping Method5 customeridcustomersprimarykey/ orderidordersprimarykey